Use API in Excel with Power Query
Nodinite can be used as an API and the data from a Log View can be transmitted to Microsoft Excel through Power Query.
Instructions
Download Power Query
Power Query can be downloaded here as 64 or 32-bit, in your preferred language.
Copy API URL
In the Log View, after a search is done, there's an option to Copy API URL.
Copy the URL
Excel
From web
Open Excel and go to the Power Query tab and click "From web".
Paste URL
Paste the URL.
Authentication
Click Windows and "Use alternative authentication".
Log in with your user name and password from Nodinite.
Parse to JSON
Go to the "Transform" tab and click "Parse" and choose JSON.
Choose Data
If too much data is selected, it won't fit in Excel.
Therefore, in this example, a limited amount of data is selected.
Tip: Uncheck the box at the bottom to save space in the columns.
Items
Unmark all columns and choose "Items"
Data
Message Type
All
Result
Close
Go to the start tab and hit "Close".
Finished
Now you can use the data with Excel.
